﻿<%@ Page Language="C#" AutoEventWireup="true" CodeFile="IframeSuppling.aspx.cs" Inherits="IframeSuppling" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
    <title></title>
    <style type="text/css">
        .style8
        {
        }
        .style9
        {
            height: 32px;
            width: 113px;
        }
        .style11
        {
            height: 32px;
            width: 155px;
        }
        .style15
        {
            height: 32px;
            width: 198px;
        }
        .style16
        {
        }
        .style19
        {
            height: 32px;
            width: 153px;
        }
        .style22
        {
            height: 32px;
            width: 76px;
        }
        .style24
        {
            height: 32px;
            width: 145px;
        }
        .style25
        {
        }
        .style26
        {
            width: 210px;
        }
        .style27
        {
            width: 116px;
        }
        .style28
        {
            width: 171px;
        }
        .style33
        {
        }
        .style35
        {
            width: 174px;
        }
        .style36
        {
            height: 32px;
            width: 174px;
        }
        .style37
        {
            height: 43px;
        }
        .style40
        {
            height: 32px;
            width: 116px;
        }
        .style44
        {
            height: 236px;
        }
        .style45
        {
            width: 136px;
        }
        .style46
        {
            height: 32px;
            width: 136px;
        }
        .style48
        {
            height: 205px;
        }
        .style49
        {
            height: 51px;
        }
        .style50
        {
            width: 139px;
            height: 29px;
        }
        .style51
        {
            height: 29px;
        }
        .style52
        {
            width: 139px;
            height: 30px;
        }
        .style53
        {
            height: 30px;
        }
        .style54
        {
            width: 139px;
            height: 36px;
        }
        .style55
        {
            height: 36px;
        }
        .style56
        {
            height: 28px;
        }
        .style57
        {
            width: 115px;
        }
        .style59
        {
            width: 66px;
        }
        .style61
        {
            width: 88px;
        }
        .style62
        {
            width: 104px;
        }
        .style64
        {
            height: 28px;
            width: 139px;
        }
        .style65
        {
            width: 108px;
        }
        .style66
        {
            width: 110px;
        }
        .style67
        {
            width: 123px;
        }
        .style68
        {
            width: 32px;
        }
        .style69
        {
            width: 68px;
        }
    </style>
</head>
<body>
    <form id="form1" runat="server">
    <div>
    
        <table style="width:55%;">
            <tr>
                <td class="style57">
                    Supplier Name :</td>
                <td class="style66">
                    <asp:Label ID="Label1" runat="server"></asp:Label>
                </td>
                <td class="style65">
                    Number Of
                    Bill :</td>
                <td class="style62">
                    <asp:Label ID="Label4" runat="server"></asp:Label>
                </td>
                <td class="style59">
                    Date :</td>
                <td class="style67">
                    <asp:Label ID="Label2" runat="server"></asp:Label>
                </td>
                <td class="style61">
                    Unit Price :</td>
                <td class="style68">
                    <asp:Label ID="Label3" runat="server"></asp:Label>
                &nbsp;</td>
                <td class="style69">
                    Discount :</td>
                <td>
                    <asp:Label ID="Label11" runat="server"></asp:Label>
                </td>
            </tr>
        </table>
        <br />
    
        <table style="width:1550px;">
            <tr>
                <td class="style8" style="border: 1px solid #000" colspan="5">
                    <table style="width: 100%; height: 416px;">
                        <tr>
                            <td class="style25" style="border: 1px solid #000">
                    Lenses :</td>
                            <td class="style26" style="border: 1px solid #000">
                                &nbsp;</td>
                            <td class="style27" style="border: 1px solid #000">
                                &nbsp;</td>
                            <td class="style28" style="border: 1px solid #000">
                                &nbsp;</td>
                        </tr>
                        <tr>
                            <td class="style25" style="border: 1px solid #000">
                    Brand Name :</td>
                            <td class="style26" style="border: 1px solid #000">
                                <asp:Label ID="Label8" runat="server"></asp:Label>
                            </td>
                            <td class="style27" style="border: 1px solid #000">
                    Vial/Disposable :</td>
                            <td class="style28" style="border: 1px solid #000">
                                <asp:Label ID="Label15" runat="server"></asp:Label>
                            </td>
                        </tr>
                        <tr>
                            <td class="style25" style="border: 1px solid #000">
                    Color :</td>
                            <td class="style26" style="border: 1px solid #000">
                                <asp:Label ID="Label16" runat="server"></asp:Label>
                            </td>
                            <td class="style27" style="border: 1px solid #000">
                    Pck :</td>
                            <td class="style28" style="border: 1px solid #000">
                                <asp:Label ID="Label17" runat="server"></asp:Label>
                            </td>
                        </tr>
                        <tr>
                            <td class="style25" style="border: 1px solid #000">
                    Sph :</td>
                            <td class="style26" style="border: 1px solid #000">
                                <asp:Label ID="Label18" runat="server"></asp:Label>
                            </td>
                            <td class="style27" style="border: 1px solid #000">
                    Cyl :</td>
                            <td class="style28" style="border: 1px solid #000">
                                <asp:Label ID="Label19" runat="server"></asp:Label>
                            </td>
                        </tr>
                        <tr>
                            <td class="style25" style="border: 1px solid #000">
                    Axis :</td>
                            <td class="style26" style="border: 1px solid #000">
                                <asp:Label ID="Label20" runat="server"></asp:Label>
                            </td>
                            <td class="style27" style="border: 1px solid #000">
                    Base Curve :</td>
                            <td class="style28" style="border: 1px solid #000">
                                <asp:Label ID="Label21" runat="server"></asp:Label>
                            </td>
                        </tr>
                        <tr>
                            <td class="style25" style="border: 1px solid #000">
                    Diameter :</td>
                            <td class="style26" style="border: 1px solid #000">
                                <asp:Label ID="Label22" runat="server"></asp:Label>
                            </td>
                            <td class="style27" style="border: 1px solid #000">
                    Lot Number :</td>
                            <td class="style28" style="border: 1px solid #000">
                                <asp:Label ID="Label23" runat="server"></asp:Label>
                            </td>
                        </tr>
                        <tr>
                            <td class="style25" style="border: 1px solid #000">
                    Expiration Date :</td>
                            <td class="style26" style="border: 1px solid #000">
                                <asp:Label ID="Label24" runat="server"></asp:Label>
                            </td>
                            <td class="style27" style="border: 1px solid #000">
                    Amount :</td>
                            <td class="style28" style="border: 1px solid #000">
                    <asp:TextBox ID="TextBox3" runat="server" Width="153px"></asp:TextBox>
                            </td>
                        </tr>
                        <tr>
                            <td class="style25" style="border: 1px solid #000">
                                &nbsp;</td>
                            <td class="style26" style="border: 1px solid #000">
                    <asp:Button ID="Button1" runat="server" Height="35px" style="margin-right: 4px" AutoPostBack="True" 
                        Text="Add" Width="85px" onclick="Button1_Click" />
                    <asp:CheckBox ID="CheckBox1" runat="server" Text="Free" AutoPostBack="True" 
                        oncheckedchanged="CheckBox1_CheckedChanged" />
                            </td>
                            <td class="style27" style="border: 1px solid #000">
                                &nbsp;</td>
                            <td class="style28" style="border: 1px solid #000">
                                &nbsp;</td>
                        </tr>
                        <tr>
                            <td class="style25" colspan="4">
                                <asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" 
                                    DataSourceID="SqlDataSource1" DataKeyNames="id">
                                    <Columns>
                                        <asp:CommandField ShowDeleteButton="True" />
                                        <asp:BoundField DataField="brandname" HeaderText="brandname" 
                                            SortExpression="brandname" />
                                        <asp:BoundField DataField="vd" HeaderText="vd" SortExpression="vd" />
                                        <asp:BoundField DataField="color" HeaderText="color" SortExpression="color" />
                                        <asp:BoundField DataField="pck" HeaderText="pck" SortExpression="pck" />
                                        <asp:BoundField DataField="sph" HeaderText="sph" SortExpression="sph" />
                                        <asp:BoundField DataField="cyl" HeaderText="cyl" 
                                            SortExpression="cyl" />
                                        <asp:BoundField DataField="axis" HeaderText="axis" 
                                            SortExpression="axis" />
                                        <asp:BoundField DataField="bc" HeaderText="bc" SortExpression="bc" />
                                        <asp:BoundField DataField="diam" HeaderText="diam" SortExpression="diam" />
                                        <asp:BoundField DataField="lot" HeaderText="lot" 
                                            SortExpression="lot" />
                                        <asp:BoundField DataField="expiredatee" HeaderText="expiredatee" 
                                            SortExpression="expiredatee" />
                                        <asp:BoundField DataField="store1" HeaderText="store1" 
                                            SortExpression="store1" />
                                    </Columns>
                                </asp:GridView>
                                <asp:SqlDataSource ID="SqlDataSource1" runat="server" 
                                    ConnectionString="<%$ ConnectionStrings:nourcenterConnectionString %>" 
                                    
                                    SelectCommand="SELECT [lot], [expiredatee], [store1], [diam], [bc], [brandname], [vd], [color], [pck], [sph], [cyl], [axis], [id] FROM [flensstored]" 
                                    DeleteCommand="DELETE FROM [flensstored] WHERE [id] = @original_id" 
                                    InsertCommand="INSERT INTO [flensstored] ([lot], [expiredatee], [store1], [diam], [bc], [brandname], [vd], [color], [pck], [sph], [cyl], [axis]) VALUES (@lot, @expiredatee, @store1, @diam, @bc, @brandname, @vd, @color, @pck, @sph, @cyl, @axis)" 
                                    OldValuesParameterFormatString="original_{0}" 
                                    
                                    UpdateCommand="UPDATE [flensstored] SET [lot] = @lot, [expiredatee] = @expiredatee, [store1] = @store1, [diam] = @diam, [bc] = @bc, [brandname] = @brandname, [vd] = @vd, [color] = @color, [pck] = @pck, [sph] = @sph, [cyl] = @cyl, [axis] = @axis WHERE [id] = @original_id">
                                    <DeleteParameters>
                                        <asp:Parameter Name="original_id" Type="Int32" />
                                    </DeleteParameters>
                                    <InsertParameters>
                                        <asp:Parameter Name="lot" Type="String" />
                                        <asp:Parameter DbType="Date" Name="expiredatee" />
                                        <asp:Parameter Name="store1" Type="Int32" />
                                        <asp:Parameter Name="diam" Type="Double" />
                                        <asp:Parameter Name="bc" Type="Double" />
                                        <asp:Parameter Name="brandname" Type="String" />
                                        <asp:Parameter Name="vd" Type="String" />
                                        <asp:Parameter Name="color" Type="String" />
                                        <asp:Parameter Name="pck" Type="Int32" />
                                        <asp:Parameter Name="sph" Type="Double" />
                                        <asp:Parameter Name="cyl" Type="Double" />
                                        <asp:Parameter Name="axis" Type="Double" />
                                    </InsertParameters>
                                    <UpdateParameters>
                                        <asp:Parameter Name="lot" Type="String" />
                                        <asp:Parameter DbType="Date" Name="expiredatee" />
                                        <asp:Parameter Name="store1" Type="Int32" />
                                        <asp:Parameter Name="diam" Type="Double" />
                                        <asp:Parameter Name="bc" Type="Double" />
                                        <asp:Parameter Name="brandname" Type="String" />
                                        <asp:Parameter Name="vd" Type="String" />
                                        <asp:Parameter Name="color" Type="String" />
                                        <asp:Parameter Name="pck" Type="Int32" />
                                        <asp:Parameter Name="sph" Type="Double" />
                                        <asp:Parameter Name="cyl" Type="Double" />
                                        <asp:Parameter Name="axis" Type="Double" />
                                        <asp:Parameter Name="original_id" Type="Int32" />
                                    </UpdateParameters>
                                </asp:SqlDataSource>
                            </td>
                        </tr>
                        <tr>
                            <td class="style56">
                                Unit Price :</td>
                            <td class="style56">
                                <asp:Label ID="Label12" runat="server"></asp:Label>
                            </td>
                            <td class="style56">
                            </td>
                            <td class="style56">
                            </td>
                        </tr>
                        <tr>
                            <td class="style44" colspan="4">
                                <asp:GridView ID="GridView2" runat="server" AutoGenerateColumns="False" 
                                    DataSourceID="SqlDataSource2" DataKeyNames="id">
                                    <Columns>
                                        <asp:CommandField ShowDeleteButton="True" />
                                        <asp:BoundField DataField="brandname" HeaderText="brandname" 
                                            SortExpression="brandname" />
                                        <asp:BoundField DataField="vd" HeaderText="vd" SortExpression="vd" />
                                        <asp:BoundField DataField="color" HeaderText="color" SortExpression="color" />
                                        <asp:BoundField DataField="pck" HeaderText="pck" SortExpression="pck" />
                                        <asp:BoundField DataField="sph" HeaderText="sph" SortExpression="sph" />
                                        <asp:BoundField DataField="cyl" HeaderText="cyl" SortExpression="cyl" />
                                        <asp:BoundField DataField="axis" HeaderText="axis" SortExpression="axis" />
                                        <asp:BoundField DataField="bc" HeaderText="bc" SortExpression="bc" />
                                        <asp:BoundField DataField="diam" HeaderText="diam" SortExpression="diam" />
                                        <asp:BoundField DataField="lot" HeaderText="lot" 
                                            SortExpression="lot" />
                                        <asp:BoundField DataField="expiredatee" HeaderText="expiredatee" 
                                            SortExpression="expiredatee" />
                                        <asp:BoundField DataField="store1" HeaderText="store1" 
                                            SortExpression="store1" />
                                    </Columns>
                                </asp:GridView>
                                <asp:SqlDataSource ID="SqlDataSource2" runat="server" 
                                    ConnectionString="<%$ ConnectionStrings:nourcenterConnectionString %>" 
                                    SelectCommand="SELECT * FROM [fklensstored]" 
                                    DeleteCommand="DELETE FROM [fklensstored] WHERE [id] = @original_id" 
                                    InsertCommand="INSERT INTO [fklensstored] ([brandname], [vd], [color], [pck], [sph], [cyl], [axis], [bc], [diam], [lot], [expiredatee], [store1]) VALUES (@brandname, @vd, @color, @pck, @sph, @cyl, @axis, @bc, @diam, @lot, @expiredatee, @store1)" 
                                    OldValuesParameterFormatString="original_{0}" 
                                    
                                    UpdateCommand="UPDATE [fklensstored] SET [brandname] = @brandname, [vd] = @vd, [color] = @color, [pck] = @pck, [sph] = @sph, [cyl] = @cyl, [axis] = @axis, [bc] = @bc, [diam] = @diam, [lot] = @lot, [expiredatee] = @expiredatee, [store1] = @store1 WHERE [id] = @original_id">
                                    <DeleteParameters>
                                        <asp:Parameter Name="original_id" Type="Int32" />
                                    </DeleteParameters>
                                    <InsertParameters>
                                        <asp:Parameter Name="brandname" Type="String" />
                                        <asp:Parameter Name="vd" Type="String" />
                                        <asp:Parameter Name="color" Type="String" />
                                        <asp:Parameter Name="pck" Type="Int32" />
                                        <asp:Parameter Name="sph" Type="Double" />
                                        <asp:Parameter Name="cyl" Type="Double" />
                                        <asp:Parameter Name="axis" Type="Double" />
                                        <asp:Parameter Name="bc" Type="Double" />
                                        <asp:Parameter Name="diam" Type="Double" />
                                        <asp:Parameter Name="lot" Type="String" />
                                        <asp:Parameter DbType="Date" Name="expiredatee" />
                                        <asp:Parameter Name="store1" Type="Int32" />
                                    </InsertParameters>
                                    <UpdateParameters>
                                        <asp:Parameter Name="brandname" Type="String" />
                                        <asp:Parameter Name="vd" Type="String" />
                                        <asp:Parameter Name="color" Type="String" />
                                        <asp:Parameter Name="pck" Type="Int32" />
                                        <asp:Parameter Name="sph" Type="Double" />
                                        <asp:Parameter Name="cyl" Type="Double" />
                                        <asp:Parameter Name="axis" Type="Double" />
                                        <asp:Parameter Name="bc" Type="Double" />
                                        <asp:Parameter Name="diam" Type="Double" />
                                        <asp:Parameter Name="lot" Type="String" />
                                        <asp:Parameter DbType="Date" Name="expiredatee" />
                                        <asp:Parameter Name="store1" Type="Int32" />
                                        <asp:Parameter Name="original_id" Type="Int32" />
                                    </UpdateParameters>
                                </asp:SqlDataSource>
                            </td>
                        </tr>
                    </table>
                </td>
                <td class="style45">
                    &nbsp;</td>
                <td class="style16" style="border: 1px solid #000" colspan="2">
                    <table style="width: 100%; height: 586px;">
                        <tr>
                            <td class="style33" style="border: 1px solid #000">
                    Soluntions :</td>
                            <td style="border: 1px solid #000">
                                &nbsp;</td>
                        </tr>
                        <tr>
                            <td class="style33" style="border: 1px solid #000">
                                Brand Name :</td>
                            <td style="border: 1px solid #000">
                                <asp:Label ID="Label9" runat="server"></asp:Label>
                            </td>
                        </tr>
                        <tr>
                            <td class="style33" style="border: 1px solid #000">
                    Bottle size :</td>
                            <td style="border: 1px solid #000">
                                <asp:DropDownList ID="DropDownList19" runat="server" Height="22px" Width="78px">
                                    <asp:ListItem>30</asp:ListItem>
                                    <asp:ListItem>50</asp:ListItem>
                                    <asp:ListItem>60</asp:ListItem>
                                    <asp:ListItem>100</asp:ListItem>
                                    <asp:ListItem>120</asp:ListItem>
                                    <asp:ListItem>240</asp:ListItem>
                                    <asp:ListItem>250</asp:ListItem>
                                    <asp:ListItem>340</asp:ListItem>
                                </asp:DropDownList>
                            </td>
                        </tr>
                        <tr>
                            <td class="style33" style="border: 1px solid #000">
                    Amount :</td>
                            <td style="border: 1px solid #000">
                    <asp:TextBox ID="TextBox7" runat="server"></asp:TextBox>
                            </td>
                        </tr>
                        <tr>
                            <td class="style33" style="border: 1px solid #000">
                    <asp:Button ID="Button4" runat="server" Text="Add" onclick="Button4_Click" />
                    <asp:CheckBox ID="CheckBox2" runat="server" Text="Free" 
                                    oncheckedchanged="CheckBox2_CheckedChanged" AutoPostBack="True" />
                            </td>
                            <td style="border: 1px solid #000">
                                &nbsp;</td>
                        </tr>
                        <tr>
                            <td class="style33" colspan="2">
                                <asp:GridView ID="GridView3" runat="server" AutoGenerateColumns="False" 
                                    DataSourceID="SqlDataSource5" DataKeyNames="id">
                                    <Columns>
                                        <asp:CommandField ShowDeleteButton="True" />
                                        <asp:BoundField DataField="brandname" HeaderText="brandname" 
                                            SortExpression="brandname" />
                                        <asp:BoundField DataField="bottlesize" HeaderText="bottlesize" 
                                            SortExpression="bottlesize" />
                                        <asp:BoundField DataField="store1" HeaderText="store1" 
                                            SortExpression="store1" />
                                    </Columns>
                                </asp:GridView>
                                <asp:SqlDataSource ID="SqlDataSource5" runat="server" 
                                    ConnectionString="<%$ ConnectionStrings:nourcenterConnectionString %>" 
                                    SelectCommand="SELECT * FROM [fsolnstored]" 
                                    DeleteCommand="DELETE FROM [fsolnstored] WHERE [id] = @original_id" 
                                    InsertCommand="INSERT INTO [fsolnstored] ([brandname], [bottlesize], [store1]) VALUES (@brandname, @bottlesize, @store1)" 
                                    OldValuesParameterFormatString="original_{0}" 
                                    
                                    UpdateCommand="UPDATE [fsolnstored] SET [brandname] = @brandname, [bottlesize] = @bottlesize, [store1] = @store1 WHERE [id] = @original_id">
                                    <DeleteParameters>
                                        <asp:Parameter Name="original_id" Type="Int32" />
                                    </DeleteParameters>
                                    <InsertParameters>
                                        <asp:Parameter Name="brandname" Type="String" />
                                        <asp:Parameter Name="bottlesize" Type="Int32" />
                                        <asp:Parameter Name="store1" Type="Int32" />
                                    </InsertParameters>
                                    <UpdateParameters>
                                        <asp:Parameter Name="brandname" Type="String" />
                                        <asp:Parameter Name="bottlesize" Type="Int32" />
                                        <asp:Parameter Name="store1" Type="Int32" />
                                        <asp:Parameter Name="original_id" Type="Int32" />
                                    </UpdateParameters>
                                </asp:SqlDataSource>
                            </td>
                        </tr>
                        <tr>
                            <td class="style56">
                                Unit Price :</td>
                            <td class="style56">
                                <asp:Label ID="Label13" runat="server"></asp:Label>
                            </td>
                        </tr>
                        <tr>
                            <td class="style48" colspan="2">
                                <asp:GridView ID="GridView4" runat="server" AutoGenerateColumns="False" 
                                    DataSourceID="SqlDataSource6" DataKeyNames="id">
                                    <Columns>
                                        <asp:CommandField ShowDeleteButton="True" />
                                        <asp:BoundField DataField="brandname" HeaderText="brandname" 
                                            SortExpression="brandname" />
                                        <asp:BoundField DataField="bottlesize" HeaderText="bottlesize" 
                                            SortExpression="bottlesize" />
                                        <asp:BoundField DataField="store1" HeaderText="store1" 
                                            SortExpression="store1" />
                                    </Columns>
                                </asp:GridView>
                                <asp:SqlDataSource ID="SqlDataSource6" runat="server" 
                                    ConnectionString="<%$ ConnectionStrings:nourcenterConnectionString %>" 
                                    SelectCommand="SELECT * FROM [fksolnstored]" 
                                    DeleteCommand="DELETE FROM [fksolnstored] WHERE [id] = @original_id" 
                                    InsertCommand="INSERT INTO [fksolnstored] ([brandname], [bottlesize], [store1]) VALUES (@brandname, @bottlesize, @store1)" 
                                    OldValuesParameterFormatString="original_{0}" 
                                    
                                    UpdateCommand="UPDATE [fksolnstored] SET [brandname] = @brandname, [bottlesize] = @bottlesize, [store1] = @store1 WHERE [id] = @original_id">
                                    <DeleteParameters>
                                        <asp:Parameter Name="original_id" Type="Int32" />
                                    </DeleteParameters>
                                    <InsertParameters>
                                        <asp:Parameter Name="brandname" Type="String" />
                                        <asp:Parameter Name="bottlesize" Type="Int32" />
                                        <asp:Parameter Name="store1" Type="Int32" />
                                    </InsertParameters>
                                    <UpdateParameters>
                                        <asp:Parameter Name="brandname" Type="String" />
                                        <asp:Parameter Name="bottlesize" Type="Int32" />
                                        <asp:Parameter Name="store1" Type="Int32" />
                                        <asp:Parameter Name="original_id" Type="Int32" />
                                    </UpdateParameters>
                                </asp:SqlDataSource>
                            </td>
                        </tr>
                    </table>
                </td>
                <td class="style16">
                    &nbsp;</td>
                <td style="border: 1px solid #000" class="style35" colspan="2">
                    <table style="width: 100%; height: 562px;">
                        <tr>
                            <td class="style50" style="border: 1px solid #000">
                    Accessories :</td>
                            <td style="border: 1px solid #000" class="style51">
                                </td>
                        </tr>
                        <tr>
                            <td class="style52" style="border: 1px solid #000">
                                Name :</td>
                            <td style="border: 1px solid #000" class="style53">
                                <asp:Label ID="Label10" runat="server"></asp:Label>
                            </td>
                        </tr>
                        <tr>
                            <td class="style54" style="border: 1px solid #000">
                                Amount :</td>
                            <td style="border: 1px solid #000" class="style55">
                                <asp:TextBox ID="TextBox8" runat="server"></asp:TextBox>
                            </td>
                        </tr>
                        <tr>
                            <td class="style64" style="border: 1px solid #000">
                    <asp:Button ID="Button6" runat="server" Text="Add" onclick="Button6_Click" />
                    <asp:CheckBox ID="CheckBox3" runat="server" Text="Free" AutoPostBack="True" 
                                    oncheckedchanged="CheckBox3_CheckedChanged" />
                            </td>
                            <td class="style56" style="border: 1px solid #000">
                                &nbsp;</td>
                        </tr>
                        <tr>
                            <td class="style49" colspan="2">
                                <asp:GridView ID="GridView5" runat="server" AutoGenerateColumns="False" 
                                    DataSourceID="SqlDataSource7" DataKeyNames="id">
                                    <Columns>
                                        <asp:CommandField ShowDeleteButton="True" />
                                        <asp:BoundField DataField="name" HeaderText="name" 
                                            SortExpression="name" />
                                        <asp:BoundField DataField="store1" HeaderText="store1" 
                                            SortExpression="store1" />
                                    </Columns>
                                </asp:GridView>
                                <asp:SqlDataSource ID="SqlDataSource7" runat="server" 
                                    ConnectionString="<%$ ConnectionStrings:nourcenterConnectionString %>" 
                                    SelectCommand="SELECT * FROM [faccstored]" 
                                    DeleteCommand="DELETE FROM [faccstored] WHERE [id] = @original_id" 
                                    InsertCommand="INSERT INTO [faccstored] ([name], [store1]) VALUES (@name, @store1)" 
                                    OldValuesParameterFormatString="original_{0}" 
                                    
                                    UpdateCommand="UPDATE [faccstored] SET [name] = @name, [store1] = @store1 WHERE [id] = @original_id">
                                    <DeleteParameters>
                                        <asp:Parameter Name="original_id" Type="Int32" />
                                    </DeleteParameters>
                                    <InsertParameters>
                                        <asp:Parameter Name="name" Type="String" />
                                        <asp:Parameter Name="store1" Type="Int32" />
                                    </InsertParameters>
                                    <UpdateParameters>
                                        <asp:Parameter Name="name" Type="String" />
                                        <asp:Parameter Name="store1" Type="Int32" />
                                        <asp:Parameter Name="original_id" Type="Int32" />
                                    </UpdateParameters>
                                </asp:SqlDataSource>
                            </td>
                        </tr>
                        <tr>
                            <td class="style64">
                                Unit Price :</td>
                            <td class="style56">
                                <asp:Label ID="Label14" runat="server"></asp:Label>
                            </td>
                        </tr>
                        <tr>
                            <td class="style37" colspan="2">
                                <asp:GridView ID="GridView6" runat="server" AutoGenerateColumns="False" 
                                    DataSourceID="SqlDataSource8" DataKeyNames="id">
                                    <Columns>
                                        <asp:CommandField ShowDeleteButton="True" />
                                        <asp:BoundField DataField="name" HeaderText="name" 
                                            SortExpression="name" />
                                        <asp:BoundField DataField="store1" HeaderText="store1" 
                                            SortExpression="store1" />
                                    </Columns>
                                </asp:GridView>
                                <asp:SqlDataSource ID="SqlDataSource8" runat="server" 
                                    ConnectionString="<%$ ConnectionStrings:nourcenterConnectionString %>" 
                                    SelectCommand="SELECT * FROM [fkaccstored]" 
                                    DeleteCommand="DELETE FROM [fkaccstored] WHERE [id] = @original_id" 
                                    InsertCommand="INSERT INTO [fkaccstored] ([name], [store1]) VALUES (@name, @store1)" 
                                    OldValuesParameterFormatString="original_{0}" 
                                    
                                    UpdateCommand="UPDATE [fkaccstored] SET [name] = @name, [store1] = @store1 WHERE [id] = @original_id">
                                    <DeleteParameters>
                                        <asp:Parameter Name="original_id" Type="Int32" />
                                    </DeleteParameters>
                                    <InsertParameters>
                                        <asp:Parameter Name="name" Type="String" />
                                        <asp:Parameter Name="store1" Type="Int32" />
                                    </InsertParameters>
                                    <UpdateParameters>
                                        <asp:Parameter Name="name" Type="String" />
                                        <asp:Parameter Name="store1" Type="Int32" />
                                        <asp:Parameter Name="original_id" Type="Int32" />
                                    </UpdateParameters>
                                </asp:SqlDataSource>
                            </td>
                        </tr>
                    </table>
                </td>
            </tr>
            <tr>
                <td class="style9">
                    &nbsp;</td>
                <td class="style15">
                    &nbsp;</td>
                <td class="style11">
                    &nbsp;</td>
                <td class="style24">
                    <asp:Label ID="Label5" runat="server" 
                        style="color: #FF0000; font-size: x-large; font-family: 'Times New Roman', Times, serif; font-style: italic"></asp:Label>
                </td>
                <td class="style22">
                    <asp:Label ID="Label6" runat="server"></asp:Label>
                </td>
                <td class="style46">
                    <asp:Label ID="Label7" runat="server"></asp:Label>
                </td>
                <td class="style40">
                    <asp:Button ID="Button3" runat="server" Height="35px" style="margin-right: 4px" 
                        Text="Insert" Width="85px" onclick="Button3_Click" />
                </td>
                <td class="style19">
                    &nbsp;</td>
                <td class="style19">
                    &nbsp;</td>
                <td class="style36">
                    &nbsp;</td>
                <td class="style36">
                    &nbsp;</td>
            </tr>
            </table>
    
    </div>
    </form>
</body>
</html>
